Title not appear in formula bar when selected due to sheet is protected.
Cause:
This behavior occurs because the worksheet is protected.
Solution:
Unprotect the worksheet.
1) Select the 'Tools' menu and select 'Protection'. (A submenu appears.)
2) Select 'Unprotect Sheet...' from the submenu.
3) If a password is defined, do the following in the displayed 'Unprotect Sheet' dialog box:
a) Type the defined password in the 'Password' box.
b) Click 'OK'. (The sheet is now unprotected.)
